﻿
供应商角色相关改动：

1.增加表yz_supplier_role

    -- ----------------------------
    -- Table structure for yz_supplier_role
    -- ----------------------------
    DROP TABLE IF EXISTS `yz_supplier_role`;
    CREATE TABLE `yz_supplier_role` (
      `ID` int(11) NOT NULL AUTO_INCREMENT,

      `RoleName` varchar(50) DEFAULT NULL COMMENT '角色名',
      PRIMARY KEY (`ID`),
      UNIQUE KEY `roleName_Unique` (`RoleName`)
    ) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT;

2.修改表：
  yz_customer
   alter table yz_customer add RoleNames text Null;
  yz_supplier
   alter table yz_supplier add SupplierRoleID int(11) Null;

   
   yz_supplier_role
   alter table yz_supplier_role add RoleDesc text Null;
   insert  into yz_supplier_role (`RoleName`,`RoleDesc`) values ('A','此类供应商速度快');

3.增加xml 
    SupplierRole.xml 需要在sqlMap.config 添加
4. 改动的xml：
    Supplier.xml  
    Customer.xml